| Close | |
|---|---|
| Annualized Return | -0.0060 |
| Annualized Std Dev | 0.1576 |
| Annualized Sharpe (Rf=0%) | -0.0380 |
| Close | |
|---|---|
| Observations | 4650.0000 |
| NAs | 1.0000 |
| Minimum | -0.1358 |
| Quartile 1 | -0.0040 |
| Median | 0.0000 |
| Arithmetic Mean | 0.0000 |
| Geometric Mean | 0.0000 |
| Quartile 3 | 0.0044 |
| Maximum | 0.1547 |
| SE Mean | 0.0001 |
| LCL Mean (0.95) | -0.0003 |
| UCL Mean (0.95) | 0.0003 |
| Variance | 0.0001 |
| Stdev | 0.0099 |
| Skewness | 0.0344 |
| Kurtosis | 36.6167 |
| Close | |
|---|---|
| Semi Deviation | 0.0071 |
| Gain Deviation | 0.0077 |
| Loss Deviation | 0.0081 |
| Downside Deviation (MAR=210%) | 0.0121 |
| Downside Deviation (Rf=0%) | 0.0071 |
| Downside Deviation (0%) | 0.0071 |
| Maximum Drawdown | 0.4253 |
| Historical VaR (95%) | -0.0136 |
| Historical ES (95%) | -0.0225 |
| Modified VaR (95%) | -0.0089 |
| Modified ES (95%) | -0.0089 |
| From | Trough | To | Depth | Length | To Trough | Recovery |
|---|---|---|---|---|---|---|
| 2002-10-10 | 2008-10-10 | 2010-09-02 | -0.4253 | 1987 | 1510 | 477 |
| 2016-09-13 | 2020-03-23 | NA | -0.3907 | 1138 | 887 | NA |
| 2012-08-03 | 2013-08-16 | 2014-12-18 | -0.2129 | 598 | 260 | 338 |
| 2014-12-19 | 2015-08-28 | 2016-07-27 | -0.1853 | 403 | 174 | 229 |
| 2010-09-03 | 2011-02-22 | 2011-11-17 | -0.1077 | 306 | 118 | 188 |
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Close | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 | NA | NA | NA | NA | NA | NA | NA | NA | 0 | 0 | 0.4 | 0.9 | 1.3 |
| 2003 | 1.1 | -0.3 | -0.7 | -0.1 | 0.4 | -0.4 | -3.1 | 0.2 | 1.3 | 0.1 | 0.5 | 0.3 | -0.8 |
| 2004 | -0.2 | 1.3 | -0.2 | 0.8 | 0.6 | 0.3 | 0.2 | -0.1 | -1.1 | -0.4 | -0.5 | -1.7 | -1.2 |
| 2005 | 0.6 | 0.2 | 0.9 | 0.7 | -0.5 | 0.1 | -0.7 | 2.1 | -0.1 | 0.7 | 1.3 | -0.5 | 4.8 |
| 2006 | 0.1 | -0.3 | -0.1 | 0.7 | 1.3 | 0.7 | 0.1 | 0 | 0.8 | 1.2 | 0.2 | 0.7 | 5.6 |
| 2007 | 0.1 | 0.6 | 1.2 | 1 | -0.5 | 0.3 | 0.1 | 1 | 0.4 | -0.1 | 1.3 | 1.2 | 6.8 |
| 2008 | 1.2 | -1.4 | -0.3 | -1.3 | -0.5 | -0.6 | -0.2 | -0.5 | -2.1 | 0.1 | -0.2 | -0.4 | -6.2 |
| 2009 | -0.6 | -0.2 | 0 | 0.4 | -0.4 | 0.8 | -0.2 | 1.2 | 0.2 | -1.9 | -0.2 | 0.1 | -0.8 |
| 2010 | 0.2 | 0.7 | 0 | -0.1 | 0.6 | 0.6 | 0 | 0.1 | -1.9 | -0.1 | -1.4 | 1.6 | 0.2 |
| 2011 | 0.2 | -0.7 | 0.4 | 0.1 | 0.5 | 0.1 | -0.1 | -0.7 | -0.3 | 0.1 | 0.7 | -0.3 | 0.2 |
| 2012 | -0.1 | 1 | 1.6 | 0.7 | 0 | 0.2 | -1 | -0.2 | 1.1 | 1 | -1.3 | -0.2 | 2.7 |
| 2013 | 0.6 | 0.1 | 1.4 | 1.1 | -2.5 | 0.9 | 1.7 | -0.9 | -0.4 | -0.8 | -0.5 | -0.9 | -0.2 |
| 2014 | 0.8 | -0.5 | -0.7 | 0.2 | -0.7 | 0.6 | -1.4 | -0.5 | 0 | -0.3 | -0.1 | 0 | -2.5 |
| 2015 | 0.1 | 0.8 | 0.3 | 1.6 | 0.9 | -1.5 | 0.3 | 1.4 | 0.4 | 0.6 | 0.7 | -0.9 | 4.7 |
| 2016 | -0.8 | 0.4 | 1.5 | -0.8 | 1.4 | 0.6 | 0.1 | 0.3 | 0 | -0.9 | -1.7 | 0.6 | 0.4 |
| 2017 | -0.1 | 0 | -0.3 | 0.2 | -0.3 | -0.2 | 0.2 | -0.1 | 0.1 | 0.1 | 0.2 | -0.1 | -0.1 |
| 2018 | -0.3 | -0.2 | 0.8 | 0 | -0.2 | -0.1 | 0.1 | 0.5 | 0.4 | 0 | 0.3 | 0.8 | 2.1 |
| 2019 | 0.1 | 0.1 | -0.2 | -0.1 | 0.2 | -0.6 | 0.4 | 0.4 | 0.1 | -0.1 | -0.3 | -0.4 | -0.4 |
| 2020 | 0.1 | -1.8 | -4.8 | 0.2 | 0.5 | 0.3 | 0.1 | 0.5 | 0.1 | -0.9 | 0.1 | 0.7 | -4.9 |
| 2021 | -0.8 | 0.9 | -0.1 | NA | NA | NA | NA | NA | NA | NA | NA | NA | 0 |
# tidytable [6 × 21]
datadate Close tic.x spy ret.x ret_1W.x ret_1M.x ret_3M.x ret_1Y.x ret_3Y.x ret_5Y.x tic.y gld ret.y ret_1W.y
<date> <dbl> <chr> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <chr> <dbl> <dbl> <dbl>
1 2002-09-25 15 SPY 84.4 0.0248 -0.0299 -0.114 -0.137 -0.171 -0.355 NA <NA> NA NA NA
2 2002-09-26 15.0 SPY 85.7 0.0164 0.0122 -0.0895 -0.138 -0.154 -0.344 NA <NA> NA NA NA
3 2002-09-27 15.0 SPY 82.8 -0.0348 -0.019 -0.102 -0.164 -0.191 -0.353 NA <NA> NA NA NA
4 2002-09-30 15 SPY 81.8 -0.0116 -0.0224 -0.112 -0.157 -0.217 -0.360 NA <NA> NA NA NA
5 2002-10-01 15 SPY 85.7 0.048 0.0414 -0.066 -0.0974 -0.178 -0.333 NA <NA> NA NA NA
6 2002-10-02 15 SPY 83.2 -0.03 -0.0142 -0.0581 -0.129 -0.212 -0.352 NA <NA> NA NA NA
# … with 6 more variables: ret_1M.y <dbl>, ret_3M.y <dbl>, ret_1Y.y <dbl>, ret_3Y.y <dbl>, ret_5Y.y <dbl>, rel <dbl>